﻿CREATE TABLE [dbo].[State] (
    [Id]             INT            NOT NULL,
    [CountryCode]    NVARCHAR (5)   NOT NULL,
    [StateCode]      NVARCHAR (50)  NOT NULL,
    [StateName]      NVARCHAR (100) NULL,
    [StateLocalName] NVARCHAR (20)  NULL,
    [StateType]      INT            NOT NULL,
    [InsertDate]     DATETIME       NOT NULL,
    [UpdateDate]     DATETIME       NOT NULL
);

